Updated Tweet Descriptors

## [1] "total tweets (English-only)"
## [1] 69197
## [1] "original non-retweets (raw count):"
## [1] 25031
## [1] "retweet counts (raw count):"
## [1] 44166
## [1] "tweets that are replies:"
## [1] 1328
## [1] "tweets that quote (retweet + added own text on top) tweets:"
## [1] 4079

Updated plot (and some specific numbers to reference)

## # A tibble: 6 x 3
##    year tweets accounts
##   <dbl>  <int>    <int>
## 1  2014   2251     1097
## 2  2015   3209     1215
## 3  2016  28254    13109
## 4  2017  10811     5188
## 5  2018  11701     4552
## 6  2019  12971     5592

Alternative to graph above if we want a labeled graph

Updated Yearly Proportion Figure (and some specific numbers to reference)

##                     topic subtotal percent_total num_retweets percent_retweets
## 1              Abstinence      182          0.26           90            49.45
## 2                  Condom     2938          4.25         1799            61.23
## 3                    PrEP    13865         20.04         6682            48.19
## 4            Circumcision      969          1.40          450            46.44
## 5                     PEP      782          1.13          297            37.98
## 6          Harm Reduction     1838          2.66         1103            60.01
## 7              Viral Load     2008          2.90         1274            63.45
## 8  Violence Against Women     1037          1.50          746            71.94
## 9                   EMTCT      271          0.39          152            56.09
## 10            Serosorting        5          0.01            1            20.00
##           topic subtotal percent_total num_retweets percent_retweets
## 11 Microbicides      341          0.49          239            70.09
## 12     Sex Work      612          0.88          286            46.73
## 13      Testing     6727          9.72         3866            57.47

Note: 40066 tweets (including retweets) do not have our themes.

Top 30 words from topicless tweets

Not sure if this help us but see if there are terms we can use to refine our word lists.

## Joining, by = "word"
## # A tibble: 10 x 2
##    word        n
##    <chr>   <int>
##  1 hiv      9092
##  2 world    4840
##  3 people   4661
##  4 aids     3878
##  5 access   3719
##  6 hands    3697
##  7 million  3653
##  8 close    3437
##  9 gap      3425
## 10 action   3420
## # A tibble: 10 x 2
##    word           n
##    <chr>      <int>
##  1 women       3317
##  2 prevention  3304
##  3 girls       3195
##  4 infected    2922
##  5 infections  2889
##  6 services    2842
##  7 treatment   2733
##  8 urgent      2361
##  9 campaign    2178
## 10 health      2136
## # A tibble: 10 x 2
##    word          n
##    <chr>     <int>
##  1 efforts    1898
##  2 day        1872
##  3 join       1630
##  4 lives      1531
##  5 adults     1514
##  6 support    1300
##  7 sexual     1292
##  8 ensure     1278
##  9 worldwide  1171
## 10 leading    1168

Updated Plot

## `summarise()` has grouped output by 'year'. You can override using the `.groups` argument.
## `summarise()` has grouped output by 'year'. You can override using the `.groups` argument.
## `summarise()` has grouped output by 'year'. You can override using the `.groups` argument.
## `summarise()` has grouped output by 'year'. You can override using the `.groups` argument.
## `summarise()` has grouped output by 'year'. You can override using the `.groups` argument.
## `summarise()` has grouped output by 'year'. You can override using the `.groups` argument.
## `summarise()` has grouped output by 'year'. You can override using the `.groups` argument.

## # A tibble: 6 x 3
## # Groups:   year [6]
##    year percent Topic 
##   <dbl>   <dbl> <chr> 
## 1  2014    6.13 Condom
## 2  2015    4.83 Condom
## 3  2016    3.92 Condom
## 4  2017    4.52 Condom
## 5  2018    5.36 Condom
## 6  2019    3.25 Condom
## # A tibble: 6 x 3
## # Groups:   year [6]
##    year percent Topic
##   <dbl>   <dbl> <chr>
## 1  2014   14.4  PrEP 
## 2  2015   21.0  PrEP 
## 3  2016    5.78 PrEP 
## 4  2017   18.4  PrEP 
## 5  2018   35.8  PrEP 
## 6  2019   39    PrEP 
## # A tibble: 6 x 3
## # Groups:   year [6]
##    year percent Topic       
##   <dbl>   <dbl> <chr>       
## 1  2014    3.47 Circumcision
## 2  2015    0.69 Circumcision
## 3  2016    1.08 Circumcision
## 4  2017    0.84 Circumcision
## 5  2018    1.51 Circumcision
## 6  2019    2.27 Circumcision
## # A tibble: 6 x 3
## # Groups:   year [6]
##    year percent Topic     
##   <dbl>   <dbl> <chr>     
## 1  2014    0.36 Abstinence
## 2  2015    0.65 Abstinence
## 3  2016    0.34 Abstinence
## 4  2017    0.31 Abstinence
## 5  2018    0.16 Abstinence
## 6  2019    0.03 Abstinence
## # A tibble: 6 x 3
## # Groups:   year [6]
##    year percent Topic
##   <dbl>   <dbl> <chr>
## 1  2014    0.4  EMTCT
## 2  2015    0.9  EMTCT
## 3  2016    0.47 EMTCT
## 4  2017    0.35 EMTCT
## 5  2018    0.09 EMTCT
## 6  2019    0.39 EMTCT
## # A tibble: 6 x 3
## # Groups:   year [6]
##    year percent Topic
##   <dbl>   <dbl> <chr>
## 1  2014    1.11 PEP  
## 2  2015    0.65 PEP  
## 3  2016    0.21 PEP  
## 4  2017    0.47 PEP  
## 5  2018    2.52 PEP  
## 6  2019    2.54 PEP  
## # A tibble: 6 x 3
## # Groups:   year [6]
##    year percent Topic  
##   <dbl>   <dbl> <chr>  
## 1  2014    8.8  Testing
## 2  2015   11.0  Testing
## 3  2016    6.78 Testing
## 4  2017    9.74 Testing
## 5  2018   10.7  Testing
## 6  2019   15.1  Testing

Top Content Generators**

**Based on number of original tweet authorship.

## .
##     HIV_Insight Sex_Worker_Hlth         DrMbere   Hlth_Literacy      HIVIreland 
##            3144             484             465             444             396 
##          UNAIDS  EPICBrowardOrg  Health_HIV2030  HopeAndHelpInc    himmoderator 
##             269             262             240             221             183 
##   itech_network       one2oneKE  GMIPartnership   HIVpxresearch   Prison_Health 
##             170             169             162             152             139 
##   ProceedNCTSTA       UNAIDS_AP     AIDSFreeGen      AniShakari     RectalMicro 
##             135             111             110             110             108

Top Tweets Based on Retweet Count

## # A tibble: 20 x 4
##    retweet_count screen_name   date       text                                  
##            <int> <chr>         <date>     <chr>                                 
##  1           907 UNAIDS        2016-12-01 "1.9 million adults became infected w…
##  2           493 accphivprn    2019-12-09 "Prevent HIV, you should #BabyYoda #H…
##  3           468 UN            2016-12-01 "The world must take urgent &amp; imm…
##  4           329 UNAIDS        2016-11-30 "Join the #worldaidsday campaign and …
##  5           320 tMSMWellness  2019-03-12 "Trans guy/trans masc and into cis gu…
##  6           274 MissUniverse  2016-12-01 "Know your status. Get Tested. \n\nPo…
##  7           239 ourladyj      2019-06-19 "When folks don’t know their worth, t…
##  8           229 UN            2016-11-30 "#HIVprevention efforts must increase…
##  9           226 ChildtoChild  2016-12-02 "#childparticipation is crucial for e…
## 10           186 UNAIDS        2016-11-22 "More than 2 million people are infec…
## 11           184 AdoreDelano   2016-10-16 "I heart my baes ❤️ #RedDress #LGBTQC…
## 12           173 philredcross  2016-12-01 "#HandsUp for #HIVPrevention. Let's s…
## 13           161 UN_Women      2017-12-01 "There are 870,000 new HIV infections…
## 14           159 UNAIDS        2017-03-08 "New UNAIDS report shows urgent need …
## 15           152 UNAIDS        2016-10-03 "UNAIDS launches #WorldAIDSDay campai…
## 16           149 UNAIDS        2019-03-11 "#HIV was the leading cause of death …
## 17           145 GHDatState    2016-12-01 "Today is #WorldAIDSDay! Together we …
## 18           145 FirstLadyRwa… 2016-12-01 "Together, striving for zero new #HIV…
## 19           141 UNAIDS        2019-10-01 "#HIV was the leading cause of death …
## 20           126 UNFPA         2018-12-01 "Ensuring young people can access com…

Top Tweets Based on Times Retweeted

NOTE: Follower count is based on their follower count at the time I collected the data (whenever that is)

## Selecting by retweet_count
## # A tibble: 10 x 6
##    screen_name   retweet_count follower_count  ratio tweet_authorship like_count
##    <chr>                 <int>          <int>  <dbl>            <int>      <int>
##  1 UNAIDS                11239         258322 0.0435              269       9617
##  2 HIV_Insight            1880          17816 0.106              3144       2459
##  3 MichelSidibe           1551          39187 0.0396               47       1983
##  4 UN                      908       12047848 0.0001                5        804
##  5 MissUniverse            705        1022563 0.0007               13       2661
##  6 UNAIDS_AP               687          11923 0.0576              111        652
##  7 HIVpxresearch           499           8778 0.0568              152        750
##  8 accphivprn              493            243 2.03                  1       1390
##  9 AniShakari              470           5188 0.0906              110        757
## 10 HIVIreland              468           3564 0.131               396        447
## # A tibble: 10 x 6
##    screen_name  retweet_count follower_count   ratio tweet_authorship like_count
##    <chr>                <int>          <int>   <dbl>            <int>      <int>
##  1 GMIPartners…           447           2705 1.65e-1              162        437
##  2 tMSMWellness           443            893 4.96e-1                4        642
##  3 UNFPA                  437         214571 2.00e-3                9        552
##  4 kentbuse               408          10892 3.75e-2               69        435
##  5 DrMbere                346            589 5.87e-1              465         71
##  6 UN_Women               323        1792006 2.00e-4                3        281
##  7 frontlineai…           318          23541 1.35e-2               58        344
##  8 philredcross           308         552795 6.00e-4                6        255
##  9 GlobalFund             305         215735 1.40e-3                6        278
## 10 UNESCO                 304        3197214 1.00e-4                5        265

Map

## 
  |                                                                            
  |                                                                      |   0%
  |                                                                            
  |                                                                      |   1%
  |                                                                            
  |=                                                                     |   1%
  |                                                                            
  |=                                                                     |   2%
  |                                                                            
  |==                                                                    |   2%
  |                                                                            
  |==                                                                    |   3%
  |                                                                            
  |==                                                                    |   4%
  |                                                                            
  |===                                                                   |   4%
  |                                                                            
  |===                                                                   |   5%
  |                                                                            
  |====                                                                  |   5%
  |                                                                            
  |====                                                                  |   6%
  |                                                                            
  |=====                                                                 |   6%
  |                                                                            
  |=====                                                                 |   7%
  |                                                                            
  |=====                                                                 |   8%
  |                                                                            
  |======                                                                |   8%
  |                                                                            
  |======                                                                |   9%
  |                                                                            
  |=======                                                               |  10%
  |                                                                            
  |=======                                                               |  11%
  |                                                                            
  |========                                                              |  11%
  |                                                                            
  |========                                                              |  12%
  |                                                                            
  |=========                                                             |  12%
  |                                                                            
  |=========                                                             |  13%
  |                                                                            
  |==========                                                            |  14%
  |                                                                            
  |==========                                                            |  15%
  |                                                                            
  |===========                                                           |  16%
  |                                                                            
  |============                                                          |  17%
  |                                                                            
  |============                                                          |  18%
  |                                                                            
  |=============                                                         |  19%
  |                                                                            
  |==============                                                        |  19%
  |                                                                            
  |==============                                                        |  20%
  |                                                                            
  |===============                                                       |  21%
  |                                                                            
  |===============                                                       |  22%
  |                                                                            
  |================                                                      |  22%
  |                                                                            
  |================                                                      |  23%
  |                                                                            
  |=================                                                     |  24%
  |                                                                            
  |=================                                                     |  25%
  |                                                                            
  |==================                                                    |  25%
  |                                                                            
  |==================                                                    |  26%
  |                                                                            
  |===================                                                   |  27%
  |                                                                            
  |============================                                          |  40%
  |                                                                            
  |=============================                                         |  42%
  |                                                                            
  |==============================                                        |  42%
  |                                                                            
  |==============================                                        |  43%
  |                                                                            
  |===============================                                       |  44%
  |                                                                            
  |================================                                      |  46%
  |                                                                            
  |=================================                                     |  48%
  |                                                                            
  |===================================                                   |  50%
  |                                                                            
  |====================================                                  |  51%
  |                                                                            
  |====================================                                  |  52%
  |                                                                            
  |=====================================                                 |  53%
  |                                                                            
  |=======================================                               |  55%
  |                                                                            
  |=======================================                               |  56%
  |                                                                            
  |========================================                              |  57%
  |                                                                            
  |=========================================                             |  58%
  |                                                                            
  |==================================================                    |  72%
  |                                                                            
  |====================================================                  |  74%
  |                                                                            
  |====================================================                  |  75%
  |                                                                            
  |=====================================================                 |  75%
  |                                                                            
  |=====================================================                 |  76%
  |                                                                            
  |============================================================          |  86%
  |                                                                            
  |=============================================================         |  87%
  |                                                                            
  |==============================================================        |  88%
  |                                                                            
  |==============================================================        |  89%
  |                                                                            
  |===============================================================       |  90%
  |                                                                            
  |==================================================================    |  94%
  |                                                                            
  |==================================================================    |  95%
  |                                                                            
  |===================================================================   |  95%
  |                                                                            
  |===================================================================   |  96%
  |                                                                            
  |====================================================================  |  97%
  |                                                                            
  |===================================================================== |  98%
  |                                                                            
  |===================================================================== |  99%
  |                                                                            
  |======================================================================| 100%
## Warning: sf layer has inconsistent datum (+proj=longlat +datum=NAD83 +no_defs).
## Need '+proj=longlat +datum=WGS84'
## 
  |                                                                            
  |                                                                      |   0%
  |                                                                            
  |=====                                                                 |   7%
  |                                                                            
  |======                                                                |   8%
  |                                                                            
  |=======                                                               |  10%
  |                                                                            
  |========                                                              |  12%
  |                                                                            
  |=========                                                             |  13%
  |                                                                            
  |==========                                                            |  14%
  |                                                                            
  |===========                                                           |  16%
  |                                                                            
  |============                                                          |  17%
  |                                                                            
  |============                                                          |  18%
  |                                                                            
  |=============                                                         |  18%
  |                                                                            
  |=============                                                         |  19%
  |                                                                            
  |==============                                                        |  20%
  |                                                                            
  |==============                                                        |  21%
  |                                                                            
  |===============                                                       |  21%
  |                                                                            
  |===============                                                       |  22%
  |                                                                            
  |================                                                      |  22%
  |                                                                            
  |================                                                      |  23%
  |                                                                            
  |=================                                                     |  25%
  |                                                                            
  |==================                                                    |  25%
  |                                                                            
  |===================                                                   |  27%
  |                                                                            
  |====================                                                  |  28%
  |                                                                            
  |====================                                                  |  29%
  |                                                                            
  |=====================                                                 |  30%
  |                                                                            
  |======================                                                |  31%
  |                                                                            
  |======================                                                |  32%
  |                                                                            
  |=======================                                               |  32%
  |                                                                            
  |=======================                                               |  33%
  |                                                                            
  |========================                                              |  34%
  |                                                                            
  |=========================                                             |  35%
  |                                                                            
  |=========================                                             |  36%
  |                                                                            
  |==========================                                            |  37%
  |                                                                            
  |===========================                                           |  39%
  |                                                                            
  |============================                                          |  40%
  |                                                                            
  |=============================                                         |  41%
  |                                                                            
  |=============================                                         |  42%
  |                                                                            
  |==============================                                        |  42%
  |                                                                            
  |==============================                                        |  43%
  |                                                                            
  |===============================                                       |  44%
  |                                                                            
  |===============================                                       |  45%
  |                                                                            
  |================================                                      |  45%
  |                                                                            
  |================================                                      |  46%
  |                                                                            
  |=================================                                     |  47%
  |                                                                            
  |==================================                                    |  48%
  |                                                                            
  |==================================                                    |  49%
  |                                                                            
  |===================================                                   |  49%
  |                                                                            
  |===================================                                   |  50%
  |                                                                            
  |=====================================                                 |  52%
  |                                                                            
  |======================================                                |  54%
  |                                                                            
  |======================================                                |  55%
  |                                                                            
  |=======================================                               |  55%
  |                                                                            
  |=======================================                               |  56%
  |                                                                            
  |========================================                              |  57%
  |                                                                            
  |=========================================                             |  58%
  |                                                                            
  |=========================================                             |  59%
  |                                                                            
  |==========================================                            |  60%
  |                                                                            
  |===========================================                           |  61%
  |                                                                            
  |============================================                          |  62%
  |                                                                            
  |============================================                          |  63%
  |                                                                            
  |============================================                          |  64%
  |                                                                            
  |=============================================                         |  64%
  |                                                                            
  |==============================================                        |  66%
  |                                                                            
  |===============================================                       |  67%
  |                                                                            
  |================================================                      |  68%
  |                                                                            
  |================================================                      |  69%
  |                                                                            
  |=================================================                     |  69%
  |                                                                            
  |=================================================                     |  70%
  |                                                                            
  |==================================================                    |  71%
  |                                                                            
  |==================================================                    |  72%
  |                                                                            
  |===================================================                   |  72%
  |                                                                            
  |===================================================                   |  73%
  |                                                                            
  |===================================================                   |  74%
  |                                                                            
  |====================================================                  |  74%
  |                                                                            
  |====================================================                  |  75%
  |                                                                            
  |=====================================================                 |  75%
  |                                                                            
  |=====================================================                 |  76%
  |                                                                            
  |======================================================                |  77%
  |                                                                            
  |======================================================                |  78%
  |                                                                            
  |=======================================================               |  78%
  |                                                                            
  |=======================================================               |  79%
  |                                                                            
  |========================================================              |  80%
  |                                                                            
  |========================================================              |  81%
  |                                                                            
  |=========================================================             |  81%
  |                                                                            
  |=========================================================             |  82%
  |                                                                            
  |==========================================================            |  82%
  |                                                                            
  |====================================================================  |  97%
  |                                                                            
  |======================================================================| 100%
## Warning: sf layer has inconsistent datum (+proj=longlat +datum=NAD83 +no_defs).
## Need '+proj=longlat +datum=WGS84'

Note: Map above using 2018 CDC Data. Prevalence Rate.

Their recommended citation: “Centers for Disease Control and Prevention. NCHHSTP AtlasPlus. Updated 2019. https://www.cdc.gov/nchhstp/atlas/index.htm. Accessed on [insert date].”

Top Counties for Tweets & Retweets

## # A tibble: 10 x 3
## # Groups:   total [9]
##    GEOID total county              
##    <chr> <int> <chr>               
##  1 11001    60 District of Columbia
##  2 13121    46 Fulton              
##  3 36061    38 New York            
##  4 36047    25 Kings               
##  5 39035    23 Cuyahoga            
##  6 06075    20 San Francisco       
##  7 48201    19 Harris              
##  8 06037    18 Los Angeles         
##  9 12011    15 Broward             
## 10 17031    15 Cook

Top 20 Hashtags (if case sensitive)

## .
##   HIVprevention             HIV   HIVPrevention            PrEP    WorldAIDSDay 
##           11618           10439            4379            4069            3308 
##   hivprevention Myrighttohealth            AIDS    worldaidsday    WorldAidsDay 
##            1623             507             497             454             449 
##        BabyYoda    MissUniverse    HIVawareness           women         HandsUp 
##             430             428             402             301             284 
##   HIVPREVENTION       Education         WAD2016        UequalsU          DREAMS 
##             255             249             230             223             181

Top 20 Hashtags (NOT case sensitive)

## .
##   hivprevention             hiv    worldaidsday            prep myrighttohealth 
##           17952           10552            4358            4242             584 
##            aids        babyyoda    missuniverse    hivawareness           women 
##             509             430             428             425             314 
##         handsup         condoms       education        uequalsu         wad2016 
##             297             296             285             257             243 
##    circumcision         endaids      hivtesting          dreams       handsupja 
##             197             194             190             181             175

Word Cloud Top 100 Words

## Loading required package: RColorBrewer
## Joining, by = "word"

Word Networks (Using top 50 bigrams or word-pairings).

## # A tibble: 20,623 x 3
##    word1       word2           n
##    <chr>       <chr>       <int>
##  1 exposure    prophylaxis   717
##  2 pre         exposure      646
##  3 hiv         prevention    523
##  4 hiv         testing       340
##  5 ht          mt            239
##  6 sex         workers       167
##  7 prophylaxis prep          159
##  8 inject      drugs         144
##  9 mt          ht            139
## 10 sexual      health        138
## # … with 20,613 more rows